SUPPORT

Select Your Region

Visit the Cary, NC, US corporate headquarters site

Americas

Europe

Middle East & Africa

Asia Pacific

View our worldwide contacts list for help finding your region

Americas

Europe

Middle East & Africa

Asia Pacific

Sign In

Get access to My SAS, trials, communities and more.

Sign Out

Get access to My SAS, trials, communities and more.

SAS Sites

sas.com
Support
Blogs
Communities
Developer
Curiosity
Videos

Documentation

Learn
Brand
PartnerNet
Merchandise
SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 52854: Pivoting a SAS® Financial Management data-entry form might cause a pink cell to be displayed

DetailsAboutRate It

A problem has been identified that might cause a SAS Financial Management data-entry form to display one pink cell when you pivot the data-entry table. An error similar to the one below is displayed in the SAS® Add-In for Microsoft Office log: 

[03/24/2014 13:13:10]
--------------- EXCEPTION REPORT ---------------
[03/24/2014 13:13:10] General Exception in FM fmOnAction.
    Control ID: FMSMenuItemRMBPivot

[03/24/2014 13:13:10] System.NullReferenceException: Object reference
not set to an instance of an object.
   at
Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.produceMap()
   at
Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.getQueryChunkMember(Int32
hierarchyIndex, Int32 memberIndex)
   at
Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.getMember(Int32
hierarchyIndex, Int32 memberIndex, Int32& block)
   at
Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.getMember(Int32
hierarchyIndex, Int32 memberIndex)
   at
Com.Sas.Ses.OfficeIntegration.View.Table.getValidSlicerMember(Int32
slicerOrdinal, Boolean& changed)
   at
Com.Sas.Ses.OfficeIntegration.View.Book.removeSharedSlicersFromListeners(List`1
ssList, String sourceTableName)
   at
SASSESExcelAddIn.TableController.PostPivot(Hierarchy[] hsColumns,
Hierarchy[] hsRows, Hierarchy[] hsSlicers, Hashtable ht, Hashtable
htSlicerMembers, List`1 ssList)
   at SASSESExcelAddIn.TableController.Pivot(Int32
row_View, Int32 column_View,
Object userInfo)
   at
SASSESExcelAddIn.ApplicationController.Pivot(Int32 row_Excel, Int32
column_Excel, Object userInfo)
   at
SASSESExcelAddIn.ApplicationController.Events_OnButtonClick(String
menuId)
[03/24/2014 13:13:10] ----------- END OF EXCEPTION REPORT ------------

This issue is most likely to occur when you are working with a form that contains shared slicers in which the tables are on different worksheets and the Refresh Active Worksheet Only option is enabled.

The data might be displayed if you select Refresh All.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Financial ManagementMicrosoft® Windows® for x645.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows 8 Enterprise 32-bit5.3_M19.3 TS1M2
Microsoft Windows 8 Enterprise x645.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows 8 Pro 32-bit5.3_M19.3 TS1M2
Microsoft Windows 8 Pro x645.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows 8.1 Enterprise 32-bit5.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows 8.1 Enterprise x645.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows 8.1 Pro5.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows 8.1 Pro 32-bit5.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows Server 2003 Datacenter Edition5.3_M19.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition5.3_M19.3 TS1M2
Microsoft Windows Server 2003 Standard Edition5.3_M19.3 TS1M2
Microsoft Windows Server 2003 for x645.3_M19.3 TS1M2
Microsoft Windows Server 20085.3_M19.3 TS1M2
Microsoft Windows Server 2008 R25.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows Server 2008 for x645.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows Server 2012 Datacenter5.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows Server 2012 R2 Datacenter5.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows Server 2012 R2 Std5.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows Server 2012 Std5.3_M15.59.3 TS1M29.4 TS1M0
Microsoft Windows XP Professional5.3_M19.3 TS1M2
Windows 7 Enterprise 32 bit5.3_M19.3 TS1M2
Windows 7 Enterprise x645.3_M15.59.3 TS1M29.4 TS1M0
Windows 7 Home Premium 32 bit5.3_M19.3 TS1M2
Windows 7 Home Premium x645.3_M19.3 TS1M2
Windows 7 Professional 32 bit5.3_M19.3 TS1M2
Windows 7 Professional x645.3_M15.59.3 TS1M29.4 TS1M0
Windows 7 Ultimate 32 bit5.3_M19.3 TS1M2
Windows 7 Ultimate x645.3_M19.3 TS1M2
Windows Vista5.3_M19.3 TS1M2
Windows Vista for x645.3_M19.3 TS1M2
64-bit Enabled AIX5.3_M15.59.3 TS1M29.4 TS1M0
64-bit Enabled Solaris5.3_M15.59.3 TS1M29.4 TS1M0
HP-UX IPF5.3_M15.59.3 TS1M29.4 TS1M0
Linux for x645.3_M15.59.3 TS1M29.4 TS1M0
Solaris for x645.3_M15.59.3 TS1M29.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.